****** Table_5_1: Within- and Cross-region Comparisons
use LandCover_GRID_CELL_v9_short.dta, clear
keep if year == 2000
keep country_id country predallports53_100km europe_harbors_def e_regiongeo e_regionpol

* Europe
summ predallports53_100km if europe_harbors_def == 1

* Europe: less aqueous
summ predallports53_100km if country_id == 144 | country_id == 157 | country_id == 201 | country_id == 76 | country_id == 2010 | country_id == 77 | country_id == 17 

* Europe: more aqueous
summ predallports53_100km if country_id == 81 | country_id == 101 | country_id == 82 | country_id == 148 | country_id == 91 | country_id == 158 | country_id == 5 | country_id == 186 | country_id == 163 | country_id == 164 | country_id == 154 | country_id == 198 | country_id == 43 | country_id == 183 | country_id == 150 | country_id == 152 | country_id == 12 

*** North Eurasia
summ predallports53_100km if country_id == 11 | country_id == 163 | country_id == 5 | country_id == 186 | country_id == 173 | country_id == 161 | country_id == 84 | country_id == 107 | country_id == 100 | country_id == 17 | country_id == 157 | country_id == 201 | country_id == 210 | country_id == 190 | country_id == 126 | country_id == 152 | country_id == 198

* North Eurasia: less aqueous
summ predallports53_100km if country_id == 11

* North Eurasia: more aqueous
summ predallports53_100km if country_id == 163 | country_id == 5 | country_id == 186 | country_id == 173 | country_id == 161 | country_id == 84 | country_id == 107 | country_id == 100 | country_id == 17 | country_id == 157 | country_id == 201 | country_id == 210 | country_id == 190 | country_id == 126 | country_id == 152 | country_id == 198

*** MENA
summ predallports53_100km if e_regionpol == 3

* MENA: less aqueous
summ predallports53_100km if country_id == 36 | country_id == 103 | country_id == 13 | country_id == 79 | country_id == 80 | country_id == 83 | country_id == 124 | country_id == 197 | country_id == 97 | country_id == 33

* MENA: more aqueous
summ predallports53_100km if country_id == 169 | country_id == 171 | country_id == 44 | country_id == 90 | country_id == 98 | country_id == 99 | country_id == 14 | country_id == 146 | country_id == 94 | country_id == 207

*** Africa
summ predallports53_100km if e_regionpol == 4

*** Africa: less aqueous
* Great Lakes region, Sahel, Congo, Ethiopia, Great Zimbabwe (Andreas)

*** Africa: more aqueous
* Niger delta/Yorubaland, Swahili coast (Andreas)

*** East asia
summ predallports53_100km if country_id == 110 | country_id == 9 | country_id == 41 | country_id == 42 | country_id == 48

* East asia: less aqueous
summ predallports53_100km if country_id == 110 

* East asia: more aqueous
summ predallports53_100km if country_id == 9 | country_id == 41 | country_id == 42 | country_id == 48

*** Southeast asia
summ predallports53_100km if e_regionpol == 7 

* Southeast asia: less aqueous
summ predallports53_100km if country_id == 10 | country_id == 55 | country_id == 123 | country_id == 49 | country_id == 34

* Southeast asia: more aqueous
summ predallports53_100km if country_id == 177 | country_id == 46 | country_id == 56 | country_id == 200 | country_id == 74

*** South asia
summ predallports53_100km if country_id == 39 | country_id == 131 | country_id == 24 | country_id == 88 | country_id == 58 | country_id == 29 | country_id == 53 

* South asia: less aqueous (calculated by Andreas)
* Bhutan, Nepal, Pakistan, Indian states (Bihar, Madhya Pradesh, Punjab, Rajasthan, Uttar Pradesh)

* South asia: more aqueous (calculated by Andreas)
* Bangladesh, Maldives, Sri Lanka, Indian states (West Bengal, Gujarat, Kerala, Tamil Nadu)

*** Global (except Antarctic)
summ predallports53_100km 

